Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 1563215 |
| Missing cells | 2595087 |
| Missing cells (%) | 7.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 274.3 MiB |
| Average record size in memory | 184.0 B |
Variable types
| Numeric | 6 |
|---|---|
| Categorical | 7 |
| Text | 6 |
| DateTime | 3 |
| Boolean | 1 |
SOURCE is highly imbalanced (72.5%) | Imbalance |
DEPARTMENT is highly imbalanced (55.9%) | Imbalance |
STATUS is highly imbalanced (94.2%) | Imbalance |
COUNTY is highly imbalanced (74.4%) | Imbalance |
DAYS TO CLOSE has 26515 (1.7%) missing values | Missing |
NEIGHBORHOOD has 46106 (2.9%) missing values | Missing |
COUNTY has 66959 (4.3%) missing values | Missing |
POLICE DISTRICT has 35265 (2.3%) missing values | Missing |
CATEGORY2 has 1001657 (64.1%) missing values | Missing |
CATEGORY3 has 1404943 (89.9%) missing values | Missing |
ZIP CODE is highly skewed (γ1 = -832.06849) | Skewed |
PARCEL ID NO is highly skewed (γ1 = 250.9088658) | Skewed |
CASE ID has unique values | Unique |
DAYS TO CLOSE has 150614 (9.6%) zeros | Zeros |
PARCEL ID NO has 35266 (2.3%) zeros | Zeros |
Reproduction
| Analysis started | 2024-02-28 09:25:25.068614 |
|---|---|
| Analysis finished | 2024-02-28 09:34:12.120086 |
| Duration | 8 minutes and 47.05 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
CASE ID
Real number (ℝ)
UNIQUE 
| Distinct | 1563215 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0140133 × 109 |
| Minimum | 2.006 × 109 |
|---|---|
| Maximum | 2.0210337 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 2.006 × 109 |
|---|---|
| 5-th percentile | 2.0071832 × 109 |
| Q1 | 2.0101856 × 109 |
| median | 2.0140975 × 109 |
| Q3 | 2.0180632 × 109 |
| 95-th percentile | 2.0200896 × 109 |
| Maximum | 2.0210337 × 109 |
| Range | 15033684 |
| Interquartile range (IQR) | 7877594 |
Descriptive statistics
| Standard deviation | 4222588.7 |
|---|---|
| Coefficient of variation (CV) | 0.0020966042 |
| Kurtosis | -1.3391166 |
| Mean | 2.0140133 × 109 |
| Median Absolute Deviation (MAD) | 3950638 |
| Skewness | -0.072037995 |
| Sum | 3.1483358 × 1015 |
| Variance | 1.7830256 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2019119972 | 1 | < 0.1% |
| 2015045877 | 1 | < 0.1% |
| 2015040302 | 1 | < 0.1% |
| 2015041682 | 1 | < 0.1% |
| 2015049038 | 1 | < 0.1% |
| 2015034811 | 1 | < 0.1% |
| 2015041579 | 1 | < 0.1% |
| 2015042453 | 1 | < 0.1% |
| 2015052481 | 1 | < 0.1% |
| 2015043953 | 1 | < 0.1% |
| Other values (1563205) | 1563205 |
| Value | Count | Frequency (%) |
| 2006000002 | 1 | |
| 2006000004 | 1 | |
| 2007000001 | 1 | |
| 2007000005 | 1 | |
| 2007000009 | 1 | |
| 2007000010 | 1 | |
| 2007000012 | 1 | |
| 2007000013 | 1 | |
| 2007000014 | 1 | |
| 2007000015 | 1 |
| Value | Count | Frequency (%) |
| 2021033686 | 1 | |
| 2021033407 | 1 | |
| 2021033233 | 1 | |
| 2021033140 | 1 | |
| 2021032869 | 1 | |
| 2021032828 | 1 | |
| 2021032612 | 1 | |
| 2021032575 | 1 | |
| 2021032525 | 1 | |
| 2021032480 | 1 |
SOURCE
Categorical
IMBALANCE 
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 67 |
| Missing (%) | < 0.1% |
| Memory size | 11.9 MiB |
| PHONE | |
|---|---|
| WEB | |
| 80585 | |
| SYS | 19226 |
| INSPE | 14690 |
| Other values (16) | 32690 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.677877 |
| Min length | 3 |
Characters and Unicode
| Total characters | 7312214 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PHONE |
|---|---|
| 2nd row | WEB |
| 3rd row | PHONE |
| 4th row | PHONE |
| 5th row | WEB |
Common Values
| Value | Count | Frequency (%) |
| PHONE | 1204236 | |
| WEB | 211721 | 13.5% |
| 80585 | 5.2% | |
| SYS | 19226 | 1.2% |
| INSPE | 14690 | 0.9% |
| BOT | 13396 | 0.9% |
| TWIR | 8311 | 0.5% |
| VOICE | 6021 | 0.4% |
| WALK | 1792 | 0.1% |
| FAX | 1538 | 0.1% |
| Other values (11) | 1632 | 0.1% |
Length
| Value | Count | Frequency (%) |
| phone | 1204236 | |
| web | 211721 | 13.5% |
| 80585 | 5.2% | |
| sys | 19226 | 1.2% |
| inspe | 14690 | 0.9% |
| bot | 13396 | 0.9% |
| twir | 8311 | 0.5% |
| voice | 6021 | 0.4% |
| walk | 1792 | 0.1% |
| fax | 1538 | 0.1% |
| Other values (11) | 1632 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 1518427 | |
| O | 1223712 | |
| P | 1219913 | |
| N | 1218950 | |
| H | 1204260 | |
| B | 225129 | 3.1% |
| W | 221824 | 3.0% |
| I | 110312 | 1.5% |
| A | 84238 | 1.2% |
| L | 82700 | 1.1% |
| Other values (12) | 202749 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 7312214 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1518427 | |
| O | 1223712 | |
| P | 1219913 | |
| N | 1218950 | |
| H | 1204260 | |
| B | 225129 | 3.1% |
| W | 221824 | 3.0% |
| I | 110312 | 1.5% |
| A | 84238 | 1.2% |
| L | 82700 | 1.1% |
| Other values (12) | 202749 | 2.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7312214 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 1518427 | |
| O | 1223712 | |
| P | 1219913 | |
| N | 1218950 | |
| H | 1204260 | |
| B | 225129 | 3.1% |
| W | 221824 | 3.0% |
| I | 110312 | 1.5% |
| A | 84238 | 1.2% |
| L | 82700 | 1.1% |
| Other values (12) | 202749 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7312214 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 1518427 | |
| O | 1223712 | |
| P | 1219913 | |
| N | 1218950 | |
| H | 1204260 | |
| B | 225129 | 3.1% |
| W | 221824 | 3.0% |
| I | 110312 | 1.5% |
| A | 84238 | 1.2% |
| L | 82700 | 1.1% |
| Other values (12) | 202749 | 2.8% |
DEPARTMENT
Categorical
IMBALANCE 
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| NHS | |
|---|---|
| Public Works | |
| Water Services | |
| Parks and Rec | |
| Health | 39543 |
| Other values (22) |
Length
| Max length | 35 |
|---|---|
| Median length | 3 |
| Mean length | 7.6318446 |
| Min length | 2 |
Characters and Unicode
| Total characters | 11930214 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NHS |
|---|---|
| 2nd row | Public Works |
| 3rd row | NHS |
| 4th row | NHS |
| 5th row | Parks and Rec |
Common Values
| Value | Count | Frequency (%) |
| NHS | 783094 | |
| Public Works | 353787 | |
| Water Services | 216852 | 13.9% |
| Parks and Rec | 87954 | 5.6% |
| Health | 39543 | 2.5% |
| KCPD | 36369 | 2.3% |
| City Managers Office | 13098 | 0.8% |
| City Planning and Development | 12575 | 0.8% |
| Northland | 8591 | 0.5% |
| NCS | 6391 | 0.4% |
| Other values (17) | 4961 | 0.3% |
Length
| Value | Count | Frequency (%) |
| nhs | 783094 | |
| public | 353787 | |
| works | 353787 | |
| water | 216852 | 9.1% |
| services | 216852 | 9.1% |
| and | 100588 | 4.2% |
| parks | 88826 | 3.7% |
| rec | 88815 | 3.7% |
| health | 39543 | 1.7% |
| kcpd | 36369 | 1.5% |
| Other values (32) | 98741 | 4.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 1007164 | 8.4% |
| r | 900261 | 7.5% |
| e | 847896 | 7.1% |
| H | 822980 | 6.9% |
| 814039 | 6.8% | |
| N | 798111 | 6.7% |
| c | 675143 | 5.7% |
| s | 672981 | 5.6% |
| i | 626675 | 5.3% |
| W | 570639 | 4.8% |
| Other values (30) | 4194325 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7151431 | |
| Uppercase Letter | 3963872 | |
| Space Separator | 814039 | 6.8% |
| Other Punctuation | 872 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 900261 | |
| e | 847896 | |
| c | 675143 | |
| s | 672981 | |
| i | 626675 | |
| a | 496002 | 6.9% |
| k | 442615 | 6.2% |
| l | 427997 | 6.0% |
| o | 376777 | 5.3% |
| u | 355543 | 5.0% |
| Other values (11) | 1329541 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1007164 | |
| H | 822980 | |
| N | 798111 | |
| W | 570639 | |
| P | 491557 | |
| R | 88827 | 2.2% |
| C | 69282 | 1.7% |
| D | 49286 | 1.2% |
| K | 36369 | 0.9% |
| M | 13514 | 0.3% |
| Other values (7) | 16143 | 0.4% |
Space Separator
| Value | Count | Frequency (%) |
| 814039 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 872 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11115303 | |
| Common | 814911 | 6.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 1007164 | 9.1% |
| r | 900261 | 8.1% |
| e | 847896 | 7.6% |
| H | 822980 | 7.4% |
| N | 798111 | 7.2% |
| c | 675143 | 6.1% |
| s | 672981 | 6.1% |
| i | 626675 | 5.6% |
| W | 570639 | 5.1% |
| a | 496002 | 4.5% |
| Other values (28) | 3697451 |
Common
| Value | Count | Frequency (%) |
| 814039 | ||
| & | 872 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11930214 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 1007164 | 8.4% |
| r | 900261 | 7.5% |
| e | 847896 | 7.1% |
| H | 822980 | 6.9% |
| 814039 | 6.8% | |
| N | 798111 | 6.7% |
| c | 675143 | 5.7% |
| s | 672981 | 5.6% |
| i | 626675 | 5.3% |
| W | 570639 | 4.8% |
| Other values (30) | 4194325 |
WORK GROUP
Text
| Distinct | 146 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
Length
| Max length | 50 |
|---|---|
| Median length | 47 |
| Mean length | 31.048004 |
| Min length | 6 |
Characters and Unicode
| Total characters | 48534706 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NHS-Dangerous Buildings- |
|---|---|
| 2nd row | Public Works-Street and Traffic-District 1 |
| 3rd row | NHS-Dangerous Buildings- |
| 4th row | NHS-Neighborhood Preservation- |
| 5th row | Parks and Rec-Central Region- |
| Value | Count | Frequency (%) |
| and | 497876 | 10.5% |
| public | 353787 | 7.5% |
| waste | 337776 | 7.2% |
| nhs-neighborhood | 317500 | 6.7% |
| nhs-solid | 299322 | 6.3% |
| preservation | 286854 | 6.1% |
| water | 216852 | 4.6% |
| works-street | 159398 | 3.4% |
| health | 143813 | 3.0% |
| nhs-animal | 139749 | 3.0% |
| Other values (206) | 1968123 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4530059 | 9.3% |
| i | 3300515 | 6.8% |
| r | 3283333 | 6.8% |
| a | 3180184 | 6.6% |
| 3157835 | 6.5% | |
| - | 3121076 | 6.4% |
| t | 2853937 | 5.9% |
| o | 2635467 | 5.4% |
| s | 2190723 | 4.5% |
| n | 2099413 | 4.3% |
| Other values (43) | 18182164 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 34166821 | |
| Uppercase Letter | 7973083 | 16.4% |
| Space Separator | 3157835 | 6.5% |
| Dash Punctuation | 3121076 | 6.4% |
| Decimal Number | 114274 | 0.2% |
| Other Punctuation | 1617 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4530059 | |
| i | 3300515 | |
| r | 3283333 | |
| a | 3180184 | |
| t | 2853937 | |
| o | 2635467 | 7.7% |
| s | 2190723 | 6.4% |
| n | 2099413 | 6.1% |
| l | 1550002 | 4.5% |
| d | 1511973 | 4.4% |
| Other values (14) | 7031215 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 2058471 | |
| N | 1136393 | |
| W | 1020241 | |
| P | 1005647 | |
| H | 976676 | |
| C | 262046 | 3.3% |
| A | 220751 | 2.8% |
| M | 215408 | 2.7% |
| T | 213447 | 2.7% |
| L | 202835 | 2.5% |
| Other values (13) | 661168 | 8.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 50862 | |
| 1 | 39053 | |
| 2 | 24359 |
Space Separator
| Value | Count | Frequency (%) |
| 3157835 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3121076 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 1617 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 42139904 | |
| Common | 6394802 | 13.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4530059 | 10.8% |
| i | 3300515 | 7.8% |
| r | 3283333 | 7.8% |
| a | 3180184 | 7.5% |
| t | 2853937 | 6.8% |
| o | 2635467 | 6.3% |
| s | 2190723 | 5.2% |
| n | 2099413 | 5.0% |
| S | 2058471 | 4.9% |
| l | 1550002 | 3.7% |
| Other values (37) | 14457800 |
Common
| Value | Count | Frequency (%) |
| 3157835 | ||
| - | 3121076 | |
| 3 | 50862 | 0.8% |
| 1 | 39053 | 0.6% |
| 2 | 24359 | 0.4% |
| & | 1617 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 48534706 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 4530059 | 9.3% |
| i | 3300515 | 6.8% |
| r | 3283333 | 6.8% |
| a | 3180184 | 6.6% |
| 3157835 | 6.5% | |
| - | 3121076 | 6.4% |
| t | 2853937 | 5.9% |
| o | 2635467 | 5.4% |
| s | 2190723 | 4.5% |
| n | 2099413 | 4.3% |
| Other values (43) | 18182164 |
TYPE
Text
| Distinct | 295 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
Length
| Max length | 48 |
|---|---|
| Median length | 29 |
| Mean length | 11.899895 |
| Min length | 2 |
Characters and Unicode
| Total characters | 18602094 |
|---|---|
| Distinct characters | 69 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Dangerous Building |
|---|---|
| 2nd row | Crack |
| 3rd row | Dangerous Building |
| 4th row | Property Maintenance |
| 5th row | Park Maintenance |
| Value | Count | Frequency (%) |
| property | 246467 | 9.1% |
| private | 213828 | 7.9% |
| 118647 | 4.4% | |
| street | 99068 | 3.7% |
| trash | 70159 | 2.6% |
| collection | 70001 | 2.6% |
| maintenance | 65340 | 2.4% |
| animal | 52113 | 1.9% |
| stray | 47867 | 1.8% |
| pothole | 39777 | 1.5% |
| Other values (343) | 1683117 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1934335 | 10.4% |
| r | 1626910 | 8.7% |
| t | 1536231 | 8.3% |
| a | 1346391 | 7.2% |
| i | 1251603 | 6.7% |
| 1143169 | 6.1% | |
| n | 1133790 | 6.1% |
| o | 1009491 | 5.4% |
| l | 663892 | 3.6% |
| P | 578906 | 3.1% |
| Other values (59) | 6377376 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 14743571 | |
| Uppercase Letter | 2509188 | 13.5% |
| Space Separator | 1143169 | 6.1% |
| Other Punctuation | 125515 | 0.7% |
| Decimal Number | 54301 | 0.3% |
| Dash Punctuation | 13999 | 0.1% |
| Open Punctuation | 6102 | < 0.1% |
| Close Punctuation | 6102 | < 0.1% |
| Initial Punctuation | 147 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1934335 | |
| r | 1626910 | |
| t | 1536231 | |
| a | 1346391 | |
| i | 1251603 | 8.5% |
| n | 1133790 | 7.7% |
| o | 1009491 | 6.8% |
| l | 663892 | 4.5% |
| c | 562616 | 3.8% |
| y | 499008 | 3.4% |
| Other values (16) | 3179304 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 578906 | |
| S | 289650 | |
| C | 240537 | |
| R | 183614 | 7.3% |
| A | 162665 | 6.5% |
| B | 147822 | 5.9% |
| T | 145769 | 5.8% |
| D | 118884 | 4.7% |
| L | 109082 | 4.3% |
| M | 108032 | 4.3% |
| Other values (15) | 424227 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 14948 | |
| 2 | 11371 | |
| 0 | 8742 | |
| 3 | 3140 | 5.8% |
| 6 | 2923 | 5.4% |
| 8 | 2812 | 5.2% |
| 4 | 2647 | 4.9% |
| 7 | 2619 | 4.8% |
| 9 | 2608 | 4.8% |
| 5 | 2491 | 4.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 116109 | |
| & | 9373 | 7.5% |
| . | 33 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1143169 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 13999 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 6102 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 6102 |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 147 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 17252759 | |
| Common | 1349335 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1934335 | 11.2% |
| r | 1626910 | 9.4% |
| t | 1536231 | 8.9% |
| a | 1346391 | 7.8% |
| i | 1251603 | 7.3% |
| n | 1133790 | 6.6% |
| o | 1009491 | 5.9% |
| l | 663892 | 3.8% |
| P | 578906 | 3.4% |
| c | 562616 | 3.3% |
| Other values (41) | 5608594 |
Common
| Value | Count | Frequency (%) |
| 1143169 | ||
| / | 116109 | 8.6% |
| 1 | 14948 | 1.1% |
| - | 13999 | 1.0% |
| 2 | 11371 | 0.8% |
| & | 9373 | 0.7% |
| 0 | 8742 | 0.6% |
| ( | 6102 | 0.5% |
| ) | 6102 | 0.5% |
| 3 | 3140 | 0.2% |
| Other values (8) | 16280 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18601947 | |
| Punctuation | 147 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1934335 | 10.4% |
| r | 1626910 | 8.7% |
| t | 1536231 | 8.3% |
| a | 1346391 | 7.2% |
| i | 1251603 | 6.7% |
| 1143169 | 6.1% | |
| n | 1133790 | 6.1% |
| o | 1009491 | 5.4% |
| l | 663892 | 3.6% |
| P | 578906 | 3.1% |
| Other values (58) | 6377229 |
Punctuation
| Value | Count | Frequency (%) |
| ‘ | 147 |
DETAIL
Text
| Distinct | 574 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
Length
| Max length | 48 |
|---|---|
| Median length | 31 |
| Mean length | 10.467135 |
| Min length | 3 |
Characters and Unicode
| Total characters | 16362382 |
|---|---|
| Distinct characters | 66 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 36 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Standard |
|---|---|
| 2nd row | District 1 |
| 3rd row | Standard |
| 4th row | Other Property Issue |
| 5th row | Central |
| Value | Count | Frequency (%) |
| all | 428758 | 14.3% |
| missed | 172087 | 5.8% |
| 135089 | 4.5% | |
| by | 107464 | 3.6% |
| district | 107235 | 3.6% |
| contractor | 89601 | 3.0% |
| property | 70100 | 2.3% |
| south | 69653 | 2.3% |
| north | 60495 | 2.0% |
| one | 57947 | 1.9% |
| Other values (600) | 1693151 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1505379 | 9.2% |
| 1428365 | 8.7% | |
| t | 1310932 | 8.0% |
| r | 1212748 | 7.4% |
| l | 1087247 | 6.6% |
| i | 896135 | 5.5% |
| o | 845654 | 5.2% |
| s | 787339 | 4.8% |
| n | 708151 | 4.3% |
| a | 643131 | 3.9% |
| Other values (56) | 5937301 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 11901213 | |
| Uppercase Letter | 2711940 | 16.6% |
| Space Separator | 1428365 | 8.7% |
| Dash Punctuation | 114893 | 0.7% |
| Other Punctuation | 108326 | 0.7% |
| Decimal Number | 78896 | 0.5% |
| Open Punctuation | 8339 | 0.1% |
| Close Punctuation | 8339 | 0.1% |
| Math Symbol | 2038 | < 0.1% |
| Initial Punctuation | 33 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1505379 | |
| t | 1310932 | |
| r | 1212748 | |
| l | 1087247 | |
| i | 896135 | 7.5% |
| o | 845654 | 7.1% |
| s | 787339 | 6.6% |
| n | 708151 | 6.0% |
| a | 643131 | 5.4% |
| c | 431294 | 3.6% |
| Other values (16) | 2473203 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 510716 | |
| S | 295407 | |
| M | 234827 | |
| C | 234346 | |
| D | 189901 | 7.0% |
| P | 175668 | 6.5% |
| N | 159626 | 5.9% |
| L | 151890 | 5.6% |
| O | 134016 | 4.9% |
| T | 120206 | 4.4% |
| Other values (15) | 505337 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 31985 | |
| 1 | 22084 | |
| 2 | 20851 | |
| 5 | 2038 | 2.6% |
| 4 | 1938 | 2.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 62947 | |
| * | 45286 | |
| ' | 64 | 0.1% |
| . | 29 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1428365 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 114893 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 8339 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 8339 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 2038 |
Initial Punctuation
| Value | Count | Frequency (%) |
| ‘ | 33 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 14613153 | |
| Common | 1749229 | 10.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1505379 | 10.3% |
| t | 1310932 | 9.0% |
| r | 1212748 | 8.3% |
| l | 1087247 | 7.4% |
| i | 896135 | 6.1% |
| o | 845654 | 5.8% |
| s | 787339 | 5.4% |
| n | 708151 | 4.8% |
| a | 643131 | 4.4% |
| A | 510716 | 3.5% |
| Other values (41) | 5105721 |
Common
| Value | Count | Frequency (%) |
| 1428365 | ||
| - | 114893 | 6.6% |
| / | 62947 | 3.6% |
| * | 45286 | 2.6% |
| 3 | 31985 | 1.8% |
| 1 | 22084 | 1.3% |
| 2 | 20851 | 1.2% |
| ( | 8339 | 0.5% |
| ) | 8339 | 0.5% |
| 5 | 2038 | 0.1% |
| Other values (5) | 4102 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 16362349 | |
| Punctuation | 33 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1505379 | 9.2% |
| 1428365 | 8.7% | |
| t | 1310932 | 8.0% |
| r | 1212748 | 7.4% |
| l | 1087247 | 6.6% |
| i | 896135 | 5.5% |
| o | 845654 | 5.2% |
| s | 787339 | 4.8% |
| n | 708151 | 4.3% |
| a | 643131 | 3.9% |
| Other values (55) | 5937268 |
Punctuation
| Value | Count | Frequency (%) |
| ‘ | 33 |
CREATION DATE
Date
| Distinct | 5229 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| Minimum | 2006-12-29 00:00:00 |
|---|---|
| Maximum | 2021-10-28 00:00:00 |
CREATION TIME
Date
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| Minimum | 2024-02-28 00:00:00 |
|---|---|
| Maximum | 2024-02-28 23:59:00 |
STATUS
Categorical
IMBALANCE 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
| RESOL | |
|---|---|
| CANC | 13818 |
| OPEN | 12657 |
| DUP | 1301 |
| ASSIG | 45 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.981396 |
| Min length | 3 |
Characters and Unicode
| Total characters | 7786993 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RESOL |
|---|---|
| 2nd row | RESOL |
| 3rd row | RESOL |
| 4th row | RESOL |
| 5th row | RESOL |
Common Values
| Value | Count | Frequency (%) |
| RESOL | 1535389 | |
| CANC | 13818 | 0.9% |
| OPEN | 12657 | 0.8% |
| DUP | 1301 | 0.1% |
| ASSIG | 45 | < 0.1% |
| FAIL | 5 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| resol | 1535389 | |
| canc | 13818 | 0.9% |
| open | 12657 | 0.8% |
| dup | 1301 | 0.1% |
| assig | 45 | < 0.1% |
| fail | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 1548046 | |
| O | 1548046 | |
| S | 1535479 | |
| L | 1535394 | |
| R | 1535389 | |
| C | 27636 | 0.4% |
| N | 26475 | 0.3% |
| P | 13958 | 0.2% |
| A | 13868 | 0.2% |
| D | 1301 | < 0.1% |
| Other values (4) | 1401 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 7786993 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1548046 | |
| O | 1548046 | |
| S | 1535479 | |
| L | 1535394 | |
| R | 1535389 | |
| C | 27636 | 0.4% |
| N | 26475 | 0.3% |
| P | 13958 | 0.2% |
| A | 13868 | 0.2% |
| D | 1301 | < 0.1% |
| Other values (4) | 1401 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7786993 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 1548046 | |
| O | 1548046 | |
| S | 1535479 | |
| L | 1535394 | |
| R | 1535389 | |
| C | 27636 | 0.4% |
| N | 26475 | 0.3% |
| P | 13958 | 0.2% |
| A | 13868 | 0.2% |
| D | 1301 | < 0.1% |
| Other values (4) | 1401 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7786993 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 1548046 | |
| O | 1548046 | |
| S | 1535479 | |
| L | 1535394 | |
| R | 1535389 | |
| C | 27636 | 0.4% |
| N | 26475 | 0.3% |
| P | 13958 | 0.2% |
| A | 13868 | 0.2% |
| D | 1301 | < 0.1% |
| Other values (4) | 1401 | < 0.1% |
EXCEEDED EST TIMEFRAME
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 23 |
| Missing (%) | < 0.1% |
| Memory size | 3.0 MiB |
| False | |
|---|---|
| True | |
| (Missing) | 23 |
| Value | Count | Frequency (%) |
| False | 1079493 | |
| True | 483699 | |
| (Missing) | 23 | < 0.1% |
CLOSED DATE
Date
| Distinct | 4995 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 12702 |
| Missing (%) | 0.8% |
| Memory size | 11.9 MiB |
| Minimum | 2007-01-04 00:00:00 |
|---|---|
| Maximum | 2022-02-11 00:00:00 |
DAYS TO CLOSE
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 2748 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 26515 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.533404 |
| Minimum | -21 |
|---|---|
| Maximum | 4525 |
| Zeros | 150614 |
| Zeros (%) | 9.6% |
| Negative | 29 |
| Negative (%) | < 0.1% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | -21 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 4 |
| Q3 | 23 |
| 95-th percentile | 261 |
| Maximum | 4525 |
| Range | 4546 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 169.57318 |
|---|---|
| Coefficient of variation (CV) | 3.2905488 |
| Kurtosis | 77.017163 |
| Mean | 51.533404 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 7.3881016 |
| Sum | 79191382 |
| Variance | 28755.063 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 322471 | |
| 0 | 150614 | 9.6% |
| 2 | 120416 | 7.7% |
| 3 | 103139 | 6.6% |
| 4 | 77824 | 5.0% |
| 5 | 57503 | 3.7% |
| 6 | 49736 | 3.2% |
| 7 | 44990 | 2.9% |
| 8 | 31128 | 2.0% |
| 9 | 20513 | 1.3% |
| Other values (2738) | 558366 | |
| (Missing) | 26515 | 1.7% |
| Value | Count | Frequency (%) |
| -21 | 17 | < 0.1% |
| -20 | 2 | < 0.1% |
| -19 | 8 | < 0.1% |
| -18 | 1 | < 0.1% |
| -1 | 1 | < 0.1% |
| 0 | 150614 | |
| 1 | 322471 | |
| 2 | 120416 | 7.7% |
| 3 | 103139 | 6.6% |
| 4 | 77824 | 5.0% |
| Value | Count | Frequency (%) |
| 4525 | 1 | |
| 4471 | 1 | |
| 4396 | 1 | |
| 4188 | 1 | |
| 4183 | 1 | |
| 4175 | 1 | |
| 4160 | 1 | |
| 4157 | 1 | |
| 4135 | 1 | |
| 4132 | 1 |
STREET ADDRESS
Text
| Distinct | 277728 |
|---|---|
| Distinct (%) | 17.8% |
| Missing | 24 |
| Missing (%) | < 0.1% |
| Memory size | 11.9 MiB |
Length
| Max length | 39 |
|---|---|
| Median length | 37 |
| Mean length | 15.80865 |
| Min length | 4 |
Characters and Unicode
| Total characters | 24711939 |
|---|---|
| Distinct characters | 75 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 67349 ? |
|---|---|
| Unique (%) | 4.3% |
Sample
| 1st row | 2317 E 50th St |
|---|---|
| 2nd row | 10329 N Forest Ave |
| 3rd row | 2623 E 10th St |
| 4th row | 2474 Chelsea Ave |
| 5th row | 400 W 31st St |
| Value | Count | Frequency (%) |
| ave | 602207 | 10.9% |
| st | 476456 | 8.6% |
| e | 327586 | 5.9% |
| n | 180177 | 3.3% |
| ter | 156915 | 2.8% |
| rd | 131274 | 2.4% |
| ne | 112479 | 2.0% |
| w | 70394 | 1.3% |
| blvd | 64833 | 1.2% |
| nw | 64756 | 1.2% |
| Other values (12145) | 3334294 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3958210 | 16.0% | |
| 1 | 1284556 | 5.2% |
| 0 | 1173280 | 4.7% |
| E | 1116467 | 4.5% |
| e | 909295 | 3.7% |
| A | 892797 | 3.6% |
| 2 | 785798 | 3.2% |
| t | 762941 | 3.1% |
| T | 726450 | 2.9% |
| 3 | 717530 | 2.9% |
| Other values (65) | 12384615 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 7637289 | |
| Decimal Number | 7183875 | |
| Lowercase Letter | 5925190 | |
| Space Separator | 3958210 | |
| Dash Punctuation | 5688 | < 0.1% |
| Other Punctuation | 1677 | < 0.1% |
| Open Punctuation | 5 | < 0.1% |
| Close Punctuation | 5 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1116467 | |
| A | 892797 | |
| T | 726450 | 9.5% |
| S | 694753 | 9.1% |
| N | 661679 | 8.7% |
| R | 501664 | 6.6% |
| V | 331386 | 4.3% |
| W | 291712 | 3.8% |
| L | 290404 | 3.8% |
| O | 286483 | 3.8% |
| Other values (16) | 1843494 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 909295 | |
| t | 762941 | |
| r | 482556 | |
| v | 427188 | 7.2% |
| n | 420855 | 7.1% |
| a | 372413 | 6.3% |
| o | 364188 | 6.1% |
| l | 354868 | 6.0% |
| d | 338821 | 5.7% |
| h | 306003 | 5.2% |
| Other values (16) | 1186062 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1284556 | |
| 0 | 1173280 | |
| 2 | 785798 | |
| 3 | 717530 | |
| 4 | 714711 | |
| 5 | 619841 | |
| 6 | 496732 | 6.9% |
| 7 | 496633 | 6.9% |
| 8 | 477639 | 6.6% |
| 9 | 417155 | 5.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 1342 | |
| , | 100 | 6.0% |
| . | 70 | 4.2% |
| / | 70 | 4.2% |
| # | 68 | 4.1% |
| & | 13 | 0.8% |
| " | 10 | 0.6% |
| : | 3 | 0.2% |
| % | 1 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 3958210 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5688 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 5 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 13562479 | |
| Common | 11149460 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 1116467 | 8.2% |
| e | 909295 | 6.7% |
| A | 892797 | 6.6% |
| t | 762941 | 5.6% |
| T | 726450 | 5.4% |
| S | 694753 | 5.1% |
| N | 661679 | 4.9% |
| R | 501664 | 3.7% |
| r | 482556 | 3.6% |
| v | 427188 | 3.1% |
| Other values (42) | 6386689 |
Common
| Value | Count | Frequency (%) |
| 3958210 | ||
| 1 | 1284556 | 11.5% |
| 0 | 1173280 | 10.5% |
| 2 | 785798 | 7.0% |
| 3 | 717530 | 6.4% |
| 4 | 714711 | 6.4% |
| 5 | 619841 | 5.6% |
| 6 | 496732 | 4.5% |
| 7 | 496633 | 4.5% |
| 8 | 477639 | 4.3% |
| Other values (13) | 424530 | 3.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24711939 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3958210 | 16.0% | |
| 1 | 1284556 | 5.2% |
| 0 | 1173280 | 4.7% |
| E | 1116467 | 4.5% |
| e | 909295 | 3.7% |
| A | 892797 | 3.6% |
| 2 | 785798 | 3.2% |
| t | 762941 | 3.1% |
| T | 726450 | 2.9% |
| 3 | 717530 | 2.9% |
| Other values (65) | 12384615 |
ZIP CODE
Real number (ℝ)
SKEWED 
| Distinct | 65 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 826 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64126.843 |
| Minimum | 4114 |
|---|---|
| Maximum | 66203 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 4114 |
|---|---|
| 5-th percentile | 64109 |
| Q1 | 64116 |
| median | 64128 |
| Q3 | 64133 |
| 95-th percentile | 64155 |
| Maximum | 66203 |
| Range | 62089 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 68.122948 |
|---|---|
| Coefficient of variation (CV) | 0.0010623156 |
| Kurtosis | 721225.59 |
| Mean | 64126.843 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | -832.06849 |
| Sum | 1.0019107 × 1011 |
| Variance | 4640.7361 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 64130 | 133154 | 8.5% |
| 64127 | 90867 | 5.8% |
| 64114 | 83166 | 5.3% |
| 64134 | 77097 | 4.9% |
| 64131 | 76437 | 4.9% |
| 64132 | 76361 | 4.9% |
| 64128 | 73073 | 4.7% |
| 64110 | 64771 | 4.1% |
| 64119 | 57224 | 3.7% |
| 64111 | 50195 | 3.2% |
| Other values (55) | 780044 |
| Value | Count | Frequency (%) |
| 4114 | 1 | < 0.1% |
| 6152 | 1 | < 0.1% |
| 63130 | 1 | < 0.1% |
| 64012 | 39 | < 0.1% |
| 64028 | 22 | < 0.1% |
| 64030 | 27 | < 0.1% |
| 64052 | 47 | < 0.1% |
| 64053 | 115 | |
| 64055 | 28 | < 0.1% |
| 64068 | 280 |
| Value | Count | Frequency (%) |
| 66203 | 1 | < 0.1% |
| 64444 | 15 | < 0.1% |
| 64167 | 194 | < 0.1% |
| 64166 | 460 | < 0.1% |
| 64165 | 486 | < 0.1% |
| 64164 | 522 | < 0.1% |
| 64163 | 1160 | 0.1% |
| 64161 | 1936 | 0.1% |
| 64160 | 89 | < 0.1% |
| 64158 | 6892 |
NEIGHBORHOOD
Text
MISSING 
| Distinct | 250 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 46106 |
| Missing (%) | 2.9% |
| Memory size | 11.9 MiB |
Length
| Max length | 42 |
|---|---|
| Median length | 29 |
| Mean length | 14.972397 |
| Min length | 2 |
Characters and Unicode
| Total characters | 22714758 |
|---|---|
| Distinct characters | 60 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Blue Hills |
|---|---|
| 2nd row | New Mark |
| 3rd row | Independence Plaza |
| 4th row | East Community Team South |
| 5th row | Westside South |
| Value | Count | Frequency (%) |
| park | 147748 | 4.3% |
| hills | 128098 | 3.7% |
| east | 108867 | 3.2% |
| creek | 104581 | 3.0% |
| blue | 98087 | 2.8% |
| south | 98018 | 2.8% |
| north | 94066 | 2.7% |
| and | 77209 | 2.2% |
| shoal | 59166 | 1.7% |
| oak | 59067 | 1.7% |
| Other values (269) | 2476354 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2024521 | 8.9% |
| 1934152 | 8.5% | |
| a | 1649498 | 7.3% |
| o | 1561057 | 6.9% |
| r | 1370100 | 6.0% |
| t | 1291903 | 5.7% |
| l | 1174709 | 5.2% |
| n | 1168235 | 5.1% |
| s | 1134269 | 5.0% |
| i | 1065864 | 4.7% |
| Other values (50) | 8340450 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 17008571 | |
| Uppercase Letter | 3515573 | 15.5% |
| Space Separator | 1934152 | 8.5% |
| Decimal Number | 140924 | 0.6% |
| Dash Punctuation | 82454 | 0.4% |
| Other Punctuation | 33084 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2024521 | |
| a | 1649498 | |
| o | 1561057 | |
| r | 1370100 | 8.1% |
| t | 1291903 | 7.6% |
| l | 1174709 | 6.9% |
| n | 1168235 | 6.9% |
| s | 1134269 | 6.7% |
| i | 1065864 | 6.3% |
| h | 746484 | 4.4% |
| Other values (15) | 3821931 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 367459 | 10.5% |
| C | 360417 | 10.3% |
| H | 349438 | 9.9% |
| P | 322701 | 9.2% |
| W | 224225 | 6.4% |
| M | 205260 | 5.8% |
| E | 203178 | 5.8% |
| B | 195938 | 5.6% |
| N | 186385 | 5.3% |
| R | 155777 | 4.4% |
| Other values (13) | 944795 |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 37402 | |
| 9 | 25165 | |
| 4 | 25165 | |
| 3 | 25165 | |
| 2 | 13161 | 9.3% |
| 7 | 10056 | 7.1% |
| 1 | 2405 | 1.7% |
| 8 | 2405 | 1.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 19923 | |
| & | 13161 |
Space Separator
| Value | Count | Frequency (%) |
| 1934152 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 82454 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 20524144 | |
| Common | 2190614 | 9.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 2024521 | 9.9% |
| a | 1649498 | 8.0% |
| o | 1561057 | 7.6% |
| r | 1370100 | 6.7% |
| t | 1291903 | 6.3% |
| l | 1174709 | 5.7% |
| n | 1168235 | 5.7% |
| s | 1134269 | 5.5% |
| i | 1065864 | 5.2% |
| h | 746484 | 3.6% |
| Other values (38) | 7337504 |
Common
| Value | Count | Frequency (%) |
| 1934152 | ||
| - | 82454 | 3.8% |
| 6 | 37402 | 1.7% |
| 9 | 25165 | 1.1% |
| 4 | 25165 | 1.1% |
| 3 | 25165 | 1.1% |
| / | 19923 | 0.9% |
| 2 | 13161 | 0.6% |
| & | 13161 | 0.6% |
| 7 | 10056 | 0.5% |
| Other values (2) | 4810 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 22714758 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 2024521 | 8.9% |
| 1934152 | 8.5% | |
| a | 1649498 | 7.3% |
| o | 1561057 | 6.9% |
| r | 1370100 | 6.0% |
| t | 1291903 | 5.7% |
| l | 1174709 | 5.2% |
| n | 1168235 | 5.1% |
| s | 1134269 | 5.0% |
| i | 1065864 | 4.7% |
| Other values (50) | 8340450 |
COUNTY
Categorical
IMBALANCE  MISSING 
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 66959 |
| Missing (%) | 4.3% |
| Memory size | 11.9 MiB |
| Jackson | |
|---|---|
| Clay | |
| Platte | 80799 |
| CLAY | 573 |
| Cass | 228 |
| Other values (8) | 292 |
Length
| Max length | 13 |
|---|---|
| Median length | 7 |
| Mean length | 6.4463307 |
| Min length | 4 |
Characters and Unicode
| Total characters | 9645361 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Jackson |
|---|---|
| 2nd row | Clay |
| 3rd row | Jackson |
| 4th row | Jackson |
| 5th row | Jackson |
Common Values
| Value | Count | Frequency (%) |
| Jackson | 1165976 | |
| Clay | 248388 | 15.9% |
| Platte | 80799 | 5.2% |
| CLAY | 573 | < 0.1% |
| Cass | 228 | < 0.1% |
| JACKSON | 219 | < 0.1% |
| jackson | 41 | < 0.1% |
| clay | 23 | < 0.1% |
| platte | 4 | < 0.1% |
| Platte County | 2 | < 0.1% |
| Other values (3) | 3 | < 0.1% |
| (Missing) | 66959 | 4.3% |
Length
| Value | Count | Frequency (%) |
| jackson | 1166236 | |
| clay | 248984 | 16.6% |
| platte | 80806 | 5.4% |
| cass | 228 | < 0.1% |
| county | 2 | < 0.1% |
| clayl | 1 | < 0.1% |
| ackson | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1495463 | |
| s | 1166474 | |
| J | 1166195 | |
| c | 1166041 | |
| o | 1166020 | |
| n | 1166020 | |
| k | 1166018 | |
| l | 329218 | 3.4% |
| C | 249411 | 2.6% |
| y | 248414 | 2.6% |
| Other values (16) | 326087 | 3.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8146132 | |
| Uppercase Letter | 1499227 | 15.5% |
| Space Separator | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1495463 | |
| s | 1166474 | |
| c | 1166041 | |
| o | 1166020 | |
| n | 1166020 | |
| k | 1166018 | |
| l | 329218 | 4.0% |
| y | 248414 | 3.0% |
| t | 161612 | 2.0% |
| e | 80805 | 1.0% |
| Other values (3) | 47 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 1166195 | |
| C | 249411 | 16.6% |
| P | 80802 | 5.4% |
| A | 793 | 0.1% |
| L | 574 | < 0.1% |
| Y | 573 | < 0.1% |
| K | 219 | < 0.1% |
| S | 219 | < 0.1% |
| O | 219 | < 0.1% |
| N | 219 | < 0.1% |
| Other values (2) | 3 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9645359 | |
| Common | 2 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1495463 | |
| s | 1166474 | |
| J | 1166195 | |
| c | 1166041 | |
| o | 1166020 | |
| n | 1166020 | |
| k | 1166018 | |
| l | 329218 | 3.4% |
| C | 249411 | 2.6% |
| y | 248414 | 2.6% |
| Other values (15) | 326085 | 3.4% |
Common
| Value | Count | Frequency (%) |
| 2 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9645361 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 1495463 | |
| s | 1166474 | |
| J | 1166195 | |
| c | 1166041 | |
| o | 1166020 | |
| n | 1166020 | |
| k | 1166018 | |
| l | 329218 | 3.4% |
| C | 249411 | 2.6% |
| y | 248414 | 2.6% |
| Other values (16) | 326087 | 3.4% |
POLICE DISTRICT
Categorical
MISSING 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 35265 |
| Missing (%) | 2.3% |
| Memory size | 11.9 MiB |
| Metro | |
|---|---|
| East | |
| Central | |
| Shoal Creek | |
| South |
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 5.8854269 |
| Min length | 4 |
Characters and Unicode
| Total characters | 8992638 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Metro |
|---|---|
| 2nd row | Shoal Creek |
| 3rd row | East |
| 4th row | East |
| 5th row | Central |
Common Values
| Value | Count | Frequency (%) |
| Metro | 383130 | |
| East | 374326 | |
| Central | 234327 | |
| Shoal Creek | 209760 | |
| South | 201792 | |
| North | 124615 | 8.0% |
| (Missing) | 35265 | 2.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| metro | 383130 | |
| east | 374326 | |
| central | 234327 | |
| shoal | 209760 | |
| creek | 209760 | |
| south | 201792 | |
| north | 124615 | 7.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 1318190 | |
| e | 1036977 | |
| r | 951832 | |
| o | 919297 | |
| a | 818413 | |
| h | 536167 | 6.0% |
| C | 444087 | 4.9% |
| l | 444087 | 4.9% |
| S | 411552 | 4.6% |
| M | 383130 | 4.3% |
| Other values (7) | 1728906 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7045168 | |
| Uppercase Letter | 1737710 | 19.3% |
| Space Separator | 209760 | 2.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 1318190 | |
| e | 1036977 | |
| r | 951832 | |
| o | 919297 | |
| a | 818413 | |
| h | 536167 | |
| l | 444087 | 6.3% |
| s | 374326 | 5.3% |
| n | 234327 | 3.3% |
| k | 209760 | 3.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 444087 | |
| S | 411552 | |
| M | 383130 | |
| E | 374326 | |
| N | 124615 | 7.2% |
Space Separator
| Value | Count | Frequency (%) |
| 209760 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8782878 | |
| Common | 209760 | 2.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 1318190 | |
| e | 1036977 | |
| r | 951832 | |
| o | 919297 | |
| a | 818413 | |
| h | 536167 | 6.1% |
| C | 444087 | 5.1% |
| l | 444087 | 5.1% |
| S | 411552 | 4.7% |
| M | 383130 | 4.4% |
| Other values (6) | 1519146 |
Common
| Value | Count | Frequency (%) |
| 209760 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8992638 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 1318190 | |
| e | 1036977 | |
| r | 951832 | |
| o | 919297 | |
| a | 818413 | |
| h | 536167 | 6.0% |
| C | 444087 | 4.9% |
| l | 444087 | 4.9% |
| S | 411552 | 4.6% |
| M | 383130 | 4.3% |
| Other values (7) | 1728906 |
PARCEL ID NO
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 175953 |
|---|---|
| Distinct (%) | 11.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 106754.49 |
| Minimum | 0 |
|---|---|
| Maximum | 9.9589235 × 108 |
| Zeros | 35266 |
| Zeros (%) | 2.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3898 |
| Q1 | 38358 |
| median | 85391 |
| Q3 | 136854 |
| 95-th percentile | 228308 |
| Maximum | 9.9589235 × 108 |
| Range | 9.9589235 × 108 |
| Interquartile range (IQR) | 98496 |
Descriptive statistics
| Standard deviation | 2353178.5 |
|---|---|
| Coefficient of variation (CV) | 22.042899 |
| Kurtosis | 76590.509 |
| Mean | 106754.49 |
| Median Absolute Deviation (MAD) | 49221 |
| Skewness | 250.90887 |
| Sum | 1.6688022 × 1011 |
| Variance | 5.5374489 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 35266 | 2.3% |
| 12614 | 4942 | 0.3% |
| 492 | 2754 | 0.2% |
| 12926 | 1265 | 0.1% |
| 128568 | 542 | < 0.1% |
| 99048 | 520 | < 0.1% |
| 98624 | 450 | < 0.1% |
| 142693 | 433 | < 0.1% |
| 12635 | 414 | < 0.1% |
| 127254 | 360 | < 0.1% |
| Other values (175943) | 1516269 |
| Value | Count | Frequency (%) |
| 0 | 35266 | |
| 1 | 28 | < 0.1% |
| 5 | 13 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 142 | < 0.1% |
| 10 | 30 | < 0.1% |
| 12 | 23 | < 0.1% |
| 14 | 3 | < 0.1% |
| 17 | 72 | < 0.1% |
| 18 | 42 | < 0.1% |
| Value | Count | Frequency (%) |
| 995892354 | 1 | < 0.1% |
| 935159351 | 1 | < 0.1% |
| 675192432 | 4 | |
| 673306734 | 1 | < 0.1% |
| 672126721 | 1 | < 0.1% |
| 647706478 | 1 | < 0.1% |
| 647476476 | 1 | < 0.1% |
| 620486201 | 1 | < 0.1% |
| 485674857 | 1 | < 0.1% |
| 250613250 | 3 |
LATITUDE
Real number (ℝ)
| Distinct | 157747 |
|---|---|
| Distinct (%) | 10.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.985272 |
| Minimum | 35.797519 |
|---|---|
| Maximum | 39.35464 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | 35.797519 |
|---|---|
| 5-th percentile | 38.915251 |
| Q1 | 38.997002 |
| median | 39.054552 |
| Q3 | 39.109302 |
| 95-th percentile | 39.257015 |
| Maximum | 39.35464 |
| Range | 3.557121 |
| Interquartile range (IQR) | 0.1123 |
Descriptive statistics
| Standard deviation | 0.52951741 |
|---|---|
| Coefficient of variation (CV) | 0.013582499 |
| Kurtosis | 31.132856 |
| Mean | 38.985272 |
| Median Absolute Deviation (MAD) | 0.056051 |
| Skewness | -5.6446435 |
| Sum | 60942361 |
| Variance | 0.28038868 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 35.797519 | 40610 | 2.6% |
| 39.100387 | 4940 | 0.3% |
| 39.014493 | 2469 | 0.2% |
| 39.099123 | 1246 | 0.1% |
| 39.074934 | 476 | < 0.1% |
| 39.285963 | 380 | < 0.1% |
| 39.031378 | 374 | < 0.1% |
| 39.100349 | 371 | < 0.1% |
| 39.307933 | 360 | < 0.1% |
| 39.074825 | 312 | < 0.1% |
| Other values (157737) | 1511677 |
| Value | Count | Frequency (%) |
| 35.797519 | 40610 | |
| 38.827084 | 1 | < 0.1% |
| 38.83482 | 5 | < 0.1% |
| 38.835025 | 6 | < 0.1% |
| 38.838219 | 29 | < 0.1% |
| 38.838324 | 5 | < 0.1% |
| 38.838331 | 34 | < 0.1% |
| 38.838343 | 3 | < 0.1% |
| 38.838587 | 8 | < 0.1% |
| 38.838841 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 39.35464 | 5 | < 0.1% |
| 39.354635 | 2 | < 0.1% |
| 39.354631 | 1 | < 0.1% |
| 39.354629 | 6 | < 0.1% |
| 39.354601 | 3 | < 0.1% |
| 39.354591 | 5 | < 0.1% |
| 39.354575 | 16 | |
| 39.353859 | 1 | < 0.1% |
| 39.353853 | 3 | < 0.1% |
| 39.353638 | 1 | < 0.1% |
LONGITUDE
Real number (ℝ)
| Distinct | 126281 |
|---|---|
| Distinct (%) | 8.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -94.792875 |
| Minimum | -103.89058 |
|---|---|
| Maximum | -94.386375 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1563215 |
| Negative (%) | 100.0% |
| Memory size | 11.9 MiB |
Quantile statistics
| Minimum | -103.89058 |
|---|---|
| 5-th percentile | -94.645131 |
| Q1 | -94.583575 |
| median | -94.55375 |
| Q3 | -94.523262 |
| 95-th percentile | -94.474424 |
| Maximum | -94.386375 |
| Range | 9.504204 |
| Interquartile range (IQR) | 0.060313 |
Descriptive statistics
| Standard deviation | 1.4864643 |
|---|---|
| Coefficient of variation (CV) | -0.015681181 |
| Kurtosis | 33.45319 |
| Mean | -94.792875 |
| Median Absolute Deviation (MAD) | 0.030071 |
| Skewness | -5.9512036 |
| Sum | -1.4818164 × 108 |
| Variance | 2.209576 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -103.890579 | 40610 | 2.6% |
| -94.577919 | 4958 | 0.3% |
| -94.529933 | 2472 | 0.2% |
| -94.577983 | 1246 | 0.1% |
| -94.591904 | 481 | < 0.1% |
| -94.576776 | 414 | < 0.1% |
| -94.472954 | 378 | < 0.1% |
| -94.540878 | 372 | < 0.1% |
| -94.59448 | 370 | < 0.1% |
| -94.588552 | 320 | < 0.1% |
| Other values (126271) | 1511594 |
| Value | Count | Frequency (%) |
| -103.890579 | 40610 | |
| -94.756681 | 1 | < 0.1% |
| -94.756298 | 1 | < 0.1% |
| -94.754146 | 1 | < 0.1% |
| -94.752204 | 1 | < 0.1% |
| -94.752202 | 1 | < 0.1% |
| -94.752171 | 12 | < 0.1% |
| -94.75217 | 2 | < 0.1% |
| -94.752163 | 8 | < 0.1% |
| -94.752122 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| -94.386375 | 26 | |
| -94.386377 | 2 | < 0.1% |
| -94.386465 | 1 | < 0.1% |
| -94.386516 | 13 | |
| -94.386648 | 12 | |
| -94.386673 | 1 | < 0.1% |
| -94.386677 | 8 | < 0.1% |
| -94.386711 | 3 | < 0.1% |
| -94.386814 | 2 | < 0.1% |
| -94.386906 | 2 | < 0.1% |
CATEGORY1
Text
| Distinct | 82 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.9 MiB |
Length
| Max length | 33 |
|---|---|
| Median length | 27 |
| Mean length | 9.007958 |
| Min length | 3 |
Characters and Unicode
| Total characters | 14081375 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Property |
|---|---|
| 2nd row | Streets |
| 3rd row | Property |
| 4th row | Property |
| 5th row | Parks & Recreation |
| Value | Count | Frequency (%) |
| trash | 373808 | |
| property | 232185 | 10.8% |
| violations | 199740 | 9.3% |
| water | 185164 | 8.6% |
| animal | 98921 | 4.6% |
| streets | 74919 | 3.5% |
| trees | 73966 | 3.4% |
| animals | 73694 | 3.4% |
| leak | 71347 | 3.3% |
| nuisance | 65646 | 3.0% |
| Other values (93) | 703849 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 1368856 | 9.7% |
| e | 1281014 | 9.1% |
| a | 1209121 | 8.6% |
| t | 1099999 | 7.8% |
| s | 1011493 | 7.2% |
| i | 990455 | 7.0% |
| o | 868987 | 6.2% |
| n | 672691 | 4.8% |
| 590024 | 4.2% | |
| l | 571371 | 4.1% |
| Other values (37) | 4417364 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 11341069 | |
| Uppercase Letter | 2092916 | 14.9% |
| Space Separator | 590024 | 4.2% |
| Other Punctuation | 57366 | 0.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 1368856 | |
| e | 1281014 | |
| a | 1209121 | |
| t | 1099999 | |
| s | 1011493 | |
| i | 990455 | |
| o | 868987 | |
| n | 672691 | 5.9% |
| l | 571371 | 5.0% |
| h | 515296 | 4.5% |
| Other values (14) | 1751786 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 457894 | |
| P | 317558 | |
| S | 274981 | |
| V | 248665 | |
| W | 225868 | |
| A | 201518 | |
| L | 119789 | 5.7% |
| N | 70214 | 3.4% |
| M | 49609 | 2.4% |
| B | 27456 | 1.3% |
| Other values (11) | 99364 | 4.7% |
Space Separator
| Value | Count | Frequency (%) |
| 590024 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 57366 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 13433985 | |
| Common | 647390 | 4.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 1368856 | 10.2% |
| e | 1281014 | 9.5% |
| a | 1209121 | 9.0% |
| t | 1099999 | 8.2% |
| s | 1011493 | 7.5% |
| i | 990455 | 7.4% |
| o | 868987 | 6.5% |
| n | 672691 | 5.0% |
| l | 571371 | 4.3% |
| h | 515296 | 3.8% |
| Other values (35) | 3844702 |
Common
| Value | Count | Frequency (%) |
| 590024 | ||
| & | 57366 | 8.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14081375 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 1368856 | 9.7% |
| e | 1281014 | 9.1% |
| a | 1209121 | 8.6% |
| t | 1099999 | 7.8% |
| s | 1011493 | 7.2% |
| i | 990455 | 7.0% |
| o | 868987 | 6.2% |
| n | 672691 | 4.8% |
| 590024 | 4.2% | |
| l | 571371 | 4.1% |
| Other values (37) | 4417364 |
CATEGORY2
Categorical
MISSING 
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1001657 |
| Missing (%) | 64.1% |
| Memory size | 11.9 MiB |
| Recycling | |
|---|---|
| Roadways | |
| Pets | |
| Buildings | |
| Weeds | |
| Other values (4) |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 7.4557161 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4186817 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Buildings |
|---|---|
| 2nd row | Roadways |
| 3rd row | Buildings |
| 4th row | Buildings |
| 5th row | Buildings |
Common Values
| Value | Count | Frequency (%) |
| Recycling | 205683 | 13.2% |
| Roadways | 74919 | 4.8% |
| Pets | 73694 | 4.7% |
| Buildings | 73234 | 4.7% |
| Weeds | 35304 | 2.3% |
| Sewer | 32457 | 2.1% |
| Parking | 29902 | 1.9% |
| Signals | 26246 | 1.7% |
| Curbs | 10119 | 0.6% |
| (Missing) | 1001657 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| recycling | 205683 | |
| roadways | 74919 | 13.3% |
| pets | 73694 | 13.1% |
| buildings | 73234 | 13.0% |
| weeds | 35304 | 6.3% |
| sewer | 32457 | 5.8% |
| parking | 29902 | 5.3% |
| signals | 26246 | 4.7% |
| curbs | 10119 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 414899 | |
| c | 411366 | |
| i | 408299 | |
| n | 335065 | 8.0% |
| g | 335065 | 8.0% |
| l | 305163 | 7.3% |
| s | 293516 | 7.0% |
| R | 280602 | 6.7% |
| y | 280602 | 6.7% |
| a | 205986 | 4.9% |
| Other values (13) | 916254 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3625259 | |
| Uppercase Letter | 561558 | 13.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 414899 | |
| c | 411366 | |
| i | 408299 | |
| n | 335065 | |
| g | 335065 | |
| l | 305163 | |
| s | 293516 | |
| y | 280602 | |
| a | 205986 | |
| d | 183457 | |
| Other values (7) | 451841 |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 280602 | |
| P | 103596 | 18.4% |
| B | 73234 | 13.0% |
| S | 58703 | 10.5% |
| W | 35304 | 6.3% |
| C | 10119 | 1.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4186817 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 414899 | |
| c | 411366 | |
| i | 408299 | |
| n | 335065 | 8.0% |
| g | 335065 | 8.0% |
| l | 305163 | 7.3% |
| s | 293516 | 7.0% |
| R | 280602 | 6.7% |
| y | 280602 | 6.7% |
| a | 205986 | 4.9% |
| Other values (13) | 916254 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4186817 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 414899 | |
| c | 411366 | |
| i | 408299 | |
| n | 335065 | 8.0% |
| g | 335065 | 8.0% |
| l | 305163 | 7.3% |
| s | 293516 | 7.0% |
| R | 280602 | 6.7% |
| y | 280602 | 6.7% |
| a | 205986 | 4.9% |
| Other values (13) | 916254 |
CATEGORY3
Categorical
MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1404943 |
| Missing (%) | 89.9% |
| Memory size | 11.9 MiB |
| Alleys | |
|---|---|
| Construction | |
| Ditch |
Length
| Max length | 12 |
|---|---|
| Median length | 6 |
| Mean length | 8.7123244 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1378917 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Construction |
|---|---|
| 2nd row | Alleys |
| 3rd row | Construction |
| 4th row | Construction |
| 5th row | Construction |
Common Values
| Value | Count | Frequency (%) |
| Alleys | 74919 | 4.8% |
| Construction | 73234 | 4.7% |
| Ditch | 10119 | 0.6% |
| (Missing) | 1404943 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| alleys | 74919 | |
| construction | 73234 | |
| ditch | 10119 | 6.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 156587 | |
| l | 149838 | |
| s | 148153 | |
| o | 146468 | |
| n | 146468 | |
| c | 83353 | 6.0% |
| i | 83353 | 6.0% |
| A | 74919 | 5.4% |
| e | 74919 | 5.4% |
| y | 74919 | 5.4% |
| Other values (5) | 239940 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1220645 | |
| Uppercase Letter | 158272 | 11.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 156587 | |
| l | 149838 | |
| s | 148153 | |
| o | 146468 | |
| n | 146468 | |
| c | 83353 | |
| i | 83353 | |
| e | 74919 | |
| y | 74919 | |
| r | 73234 | |
| Other values (2) | 83353 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 74919 | |
| C | 73234 | |
| D | 10119 | 6.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1378917 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 156587 | |
| l | 149838 | |
| s | 148153 | |
| o | 146468 | |
| n | 146468 | |
| c | 83353 | 6.0% |
| i | 83353 | 6.0% |
| A | 74919 | 5.4% |
| e | 74919 | 5.4% |
| y | 74919 | 5.4% |
| Other values (5) | 239940 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1378917 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 156587 | |
| l | 149838 | |
| s | 148153 | |
| o | 146468 | |
| n | 146468 | |
| c | 83353 | 6.0% |
| i | 83353 | 6.0% |
| A | 74919 | 5.4% |
| e | 74919 | 5.4% |
| y | 74919 | 5.4% |
| Other values (5) | 239940 |
| CASE ID | SOURCE | DEPARTMENT | WORK GROUP | TYPE | DETAIL | CREATION DATE | CREATION TIME | STATUS | EXCEEDED EST TIMEFRAME | CLOSED DATE | DAYS TO CLOSE | STREET ADDRESS | ZIP CODE | NEIGHBORHOOD | COUNTY | POLICE DISTRICT | PARCEL ID NO | LATITUDE | LONGITUDE | CATEGORY1 | CATEGORY2 | CATEGORY3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2019119972 | PHONE | NHS | NHS-Dangerous Buildings- | Dangerous Building | Standard | 06/24/2019 | 07:40 AM | RESOL | Y | 11/19/2021 | 879.0 | 2317 E 50th St | 64130.0 | Blue Hills | Jackson | Metro | 138863 | 39.035489 | -94.557309 | Property | Buildings | Construction |
| 1 | 2019207923 | WEB | Public Works | Public Works-Street and Traffic-District 1 | Crack | District 1 | 12/22/2019 | 07:56 PM | RESOL | Y | 06/26/2020 | 187.0 | 10329 N Forest Ave | 64155.0 | New Mark | Clay | Shoal Creek | 103703 | 39.281960 | -94.564453 | Streets | Roadways | Alleys |
| 2 | 2021005976 | PHONE | NHS | NHS-Dangerous Buildings- | Dangerous Building | Standard | 01/19/2021 | 02:43 PM | RESOL | Y | 11/15/2021 | 300.0 | 2623 E 10th St | 64127.0 | Independence Plaza | Jackson | East | 10703 | 39.101272 | -94.549951 | Property | Buildings | Construction |
| 3 | 2020149407 | PHONE | NHS | NHS-Neighborhood Preservation- | Property Maintenance | Other Property Issue | 11/25/2020 | 09:19 AM | RESOL | Y | 04/26/2021 | 152.0 | 2474 Chelsea Ave | 64127.0 | East Community Team South | Jackson | East | 19178 | 39.079895 | -94.526959 | Property | Buildings | Construction |
| 4 | 2020054721 | WEB | Parks and Rec | Parks and Rec-Central Region- | Park Maintenance | Central | 04/18/2020 | 05:10 PM | RESOL | N | 04/30/2020 | 12.0 | 400 W 31st St | 64108.0 | Westside South | Jackson | Central | 128568 | 39.074934 | -94.591904 | Parks & Recreation | NaN | NaN |
| 5 | 2019182182 | PHONE | NHS | NHS-Dangerous Buildings- | Dangerous Building | Standard | 10/21/2019 | 10:29 AM | RESOL | Y | 08/03/2020 | 287.0 | 4043 Kenwood Ave | 64110.0 | South Hyde Park | Jackson | Central | 133291 | 39.052983 | -94.577808 | Property | Buildings | Construction |
| 6 | 2019184705 | WEB | NHS | NHS-Solid Waste- | Recycling | Missed by City | 10/25/2019 | 10:02 AM | RESOL | N | 10/28/2019 | 3.0 | 637 E 62nd St | 64110.0 | Western 49-63 | Jackson | Metro | 106106 | 39.014160 | -94.579673 | Trash | Recycling | NaN |
| 7 | 2019184590 | WEB | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Trimming | Tree Limbs | 10/25/2019 | 04:44 AM | RESOL | Y | 12/04/2019 | 40.0 | 10901 Blue Ridge Blvd | 64134.0 | Ruskin Heights | Jackson | South | 59546 | 38.924085 | -94.507192 | Trees | NaN | NaN |
| 8 | 2020095175 | PHONE | NHS | NHS-Dangerous Buildings- | Dangerous Building | Standard | 07/13/2020 | 08:00 AM | RESOL | Y | 11/29/2021 | 504.0 | 4215 E 60th St | 64130.0 | Swope Parkway-Elmwood | Jackson | Metro | 326 | 39.016565 | -94.536611 | Property | Buildings | Construction |
| 9 | 2015094486 | PHONE | NHS | NHS-Solid Waste-Administration | Services | Service Issue / Problem | 08/07/2015 | 01:45 PM | RESOL | Y | 05/27/2016 | 294.0 | 4518 N Askew Ave | 64117.0 | Antioch Acres | Clay | Shoal Creek | 76946 | 39.176846 | -94.537416 | Trash | Recycling | NaN |
| CASE ID | SOURCE | DEPARTMENT | WORK GROUP | TYPE | DETAIL | CREATION DATE | CREATION TIME | STATUS | EXCEEDED EST TIMEFRAME | CLOSED DATE | DAYS TO CLOSE | STREET ADDRESS | ZIP CODE | NEIGHBORHOOD | COUNTY | POLICE DISTRICT | PARCEL ID NO | LATITUDE | LONGITUDE | CATEGORY1 | CATEGORY2 | CATEGORY3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1563205 | 2019175846 | PHONE | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Removal | Declining | 10/04/2019 | 11:35 AM | RESOL | Y | 12/04/2019 | 61.0 | 3942 Wyandotte St | 64111.0 | Old Westport | Jackson | Central | 132644 | 39.055001 | -94.588843 | Trees | NaN | NaN |
| 1563206 | 2019175727 | PHONE | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Removal | Tree Limbs | 10/04/2019 | 09:32 AM | RESOL | Y | 11/05/2019 | 32.0 | 9014 E 88th Ter | 64138.0 | White Oak | Jackson | South | 66408 | 38.962712 | -94.478245 | Trees | NaN | NaN |
| 1563207 | 2019176019 | PHONE | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Trimming | Block Pruning | 10/04/2019 | 03:51 PM | RESOL | N | 10/11/2019 | 7.0 | 9208 NE 109th Ct | 64157.0 | Shoal Creek | Clay | Shoal Creek | 209678 | 39.289643 | -94.464390 | Trees | NaN | NaN |
| 1563208 | 2019175967 | PHONE | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Trimming | Tree Limbs | 10/04/2019 | 02:46 PM | RESOL | Y | 10/30/2019 | 26.0 | 3106 Peery Ave | 64127.0 | Independence Plaza | Jackson | East | 10876 | 39.099803 | -94.545545 | Trees | NaN | NaN |
| 1563209 | 2019175920 | PHONE | Parks and Rec | Parks and Rec-Landscape Services-Forestry | Trimming | Tree Limbs | 10/04/2019 | 01:04 PM | RESOL | Y | 10/19/2019 | 15.0 | 5048 NE 56th Pl | 64119.0 | Ravenwood-Somerset | Clay | Shoal Creek | 90408 | 39.195871 | -94.518434 | Trees | NaN | NaN |
| 1563210 | 2019175624 | PHONE | NHS | NHS-Solid Waste- | Trash Collection | Missed by Contractor North | 10/03/2019 | 06:18 PM | RESOL | N | 10/05/2019 | 2.0 | 10415 NW 87th St | 64153.0 | KCI & 2nd Creek | Platte | North | 211724 | 39.251356 | -94.702155 | Trash | Recycling | NaN |
| 1563211 | 2019176099 | PHONE | Parks and Rec | Parks and Rec-Central Region- | Park Maintenance | Central | 10/05/2019 | 08:13 AM | RESOL | N | 10/10/2019 | 5.0 | 2308 Topping Ave | 64127.0 | South Blue Valley | Jackson | East | 20118 | 39.082634 | -94.515668 | Parks & Recreation | NaN | NaN |
| 1563212 | 2019176030 | PHONE | NHS | NHS-Solid Waste- | Dead Animal | Curb | 10/04/2019 | 04:07 PM | RESOL | N | 10/05/2019 | 1.0 | 5437 South Benton Ave | 64130.0 | North Town Fork Creek | Jackson | Metro | 36265 | 39.026897 | -94.551349 | Animals | Pets | NaN |
| 1563213 | 2019176115 | PHONE | Public Works | Public Works-Capital Projects-Traffic Permits | Plate | Missing / Displaced | 10/05/2019 | 04:50 PM | RESOL | Y | 12/04/2019 | 60.0 | 1201 W 75th St | 64114.0 | Ward Parkway | Jackson | Metro | 120444 | 38.992568 | -94.604029 | Streets | Roadways | Alleys |
| 1563214 | 2019172858 | WEB | City Planning and Development | City Planning and Development-Permit Compliance- | Construction Issue/Concern | Work Without Permit | 09/27/2019 | 08:01 PM | RESOL | Y | 10/06/2019 | 9.0 | 10799 NW Skyview Ave | 64154.0 | KCI & 2nd Creek | Platte | North | 207756 | 39.288525 | -94.651254 | Property | Buildings | Construction |